﻿CREATE TABLE [dbo].[UserAccountRole] (
    [UserAccountId] UNIQUEIDENTIFIER NOT NULL,
    [RoleId]        UNIQUEIDENTIFIER NOT NULL,
    CONSTRAINT [PK_UserAccountRole] PRIMARY KEY CLUSTERED ([UserAccountId] ASC, [RoleId] ASC),
    CONSTRAINT [FK_UserAccountRole_Role] FOREIGN KEY ([RoleId]) REFERENCES [dbo].[Role] ([Id]),
    CONSTRAINT [FK_UserAccountRole_UserAccount] FOREIGN KEY ([UserAccountId]) REFERENCES [dbo].[UserAccount] ([Id])
);

